PRINT '<<< Creating Master Data >>>'
/*User_Permission_Type*/
INSERT INTO [dbo].[user_permission_type] (name, Description, Status, CreatedBy, CreatedOn, ModifiedBy, ModifiedOn) VALUES ('Add Question', 'Add Question', 1, 'system', GETDATE(), NULL, NULL);
INSERT INTO [dbo].[user_permission_type] (name, Description, Status, CreatedBy, CreatedOn, ModifiedBy, ModifiedOn) VALUES ('Edit Question', 'Edit Question', 1, 'system', GETDATE(), NULL, NULL);
INSERT INTO [dbo].[user_permission_type] (name, Description, Status, CreatedBy, CreatedOn, ModifiedBy, ModifiedOn) VALUES ('View Question', 'View Question', 1, 'system', GETDATE(), NULL, NULL);
INSERT INTO [dbo].[user_permission_type] (name, Description, Status, CreatedBy, CreatedOn, ModifiedBy, ModifiedOn) VALUES ('Add Exam', 'Add Exam', 1, 'system', GETDATE(), NULL, NULL);
INSERT INTO [dbo].[user_permission_type] (name, Description, Status, CreatedBy, CreatedOn, ModifiedBy, ModifiedOn) VALUES ('Edit Exam', 'Edit Exam', 1, 'system', GETDATE(), NULL, NULL);
INSERT INTO [dbo].[user_permission_type] (name, Description, Status, CreatedBy, CreatedOn, ModifiedBy, ModifiedOn) VALUES ('View Exam', 'View Exam', 1, 'system', GETDATE(), NULL, NULL);
INSERT INTO [dbo].[user_permission_type] (name, Description, Status, CreatedBy, CreatedOn, ModifiedBy, ModifiedOn) VALUES ('Add User', 'Add User', 1, 'system', GETDATE(), NULL, NULL);
INSERT INTO [dbo].[user_permission_type] (name, Description, Status, CreatedBy, CreatedOn, ModifiedBy, ModifiedOn) VALUES ('Edit User', 'Edit User', 1, 'system', GETDATE(), NULL, NULL);
INSERT INTO [dbo].[user_permission_type] (name, Description, Status, CreatedBy, CreatedOn, ModifiedBy, ModifiedOn) VALUES ('View User', 'View User', 1, 'system', GETDATE(), NULL, NULL);

/*User_Role_Type*/
INSERT INTO [dbo].[User_Role_Type] (Name,Description,Status,CreatedBy ,CreatedOn) VALUES ('Examiner','Examiner',1 ,'system',getDate());
INSERT INTO [dbo].[User_Role_Type] (Name,Description,Status,CreatedBy ,CreatedOn) VALUES ('Examinee','Examinee',1 ,'system',getDate());


/*User_Role_Permission*/
INSERT INTO [dbo].[user_Role_Permission] (User_Role_TypeID,User_Permission_TypeID) VALUES (1,1);
INSERT INTO [dbo].[user_Role_Permission] (User_Role_TypeID,User_Permission_TypeID) VALUES (1,2);
INSERT INTO [dbo].[user_Role_Permission] (User_Role_TypeID,User_Permission_TypeID) VALUES (1,3);
INSERT INTO [dbo].[user_Role_Permission] (User_Role_TypeID,User_Permission_TypeID) VALUES (1,4);
INSERT INTO [dbo].[user_Role_Permission] (User_Role_TypeID,User_Permission_TypeID) VALUES (1,5);
INSERT INTO [dbo].[user_Role_Permission] (User_Role_TypeID,User_Permission_TypeID) VALUES (1,6);
INSERT INTO [dbo].[user_Role_Permission] (User_Role_TypeID,User_Permission_TypeID) VALUES (1,7);
INSERT INTO [dbo].[user_Role_Permission] (User_Role_TypeID,User_Permission_TypeID) VALUES (1,8);
INSERT INTO [dbo].[user_Role_Permission] (User_Role_TypeID,User_Permission_TypeID) VALUES (1,9);


/*User_Info*/
INSERT INTO [dbo].[User_Info] (UserName,Password,Retry_Password_Count,First_Name,Last_Name,CreatedBy,CreatedOn,EmpCode,status) VALUES ('system','VLUwclQO7rj46TQ+cfKBdg==',1,'system','system','system',GETDATE(),'system',1); 

/*User_Role*/

INSERT INTO [dbo].[User_Role] (User_InfoID,User_Role_TypeID) VALUES (1,1);

/*Level Type Master*/
INSERT INTO [dbo].[Level_Type] (Name,Description,Status,CreatedBy,CreatedOn) VALUES ('Easy','Easy',2,'system',getDate());
INSERT INTO [dbo].[Level_Type] (Name,Description,Status,CreatedBy,CreatedOn) VALUES ('Medium','Easy',2,'system',getDate());
INSERT INTO [dbo].[Level_Type] (Name,Description,Status,CreatedBy,CreatedOn) VALUES ('Hard','Easy',2,'system',getDate());

/*Category Type Master*/
INSERT INTO [dbo].[Category_Type] (Name,Description,Status,CreatedBy,CreatedOn) VALUES ('Womenswear','Womenswear',2,'system',getDate());
INSERT INTO [dbo].[Category_Type] (Name,Description,Status,CreatedBy,CreatedOn) VALUES ('Menswear','Menswear',2,'system',getDate());
INSERT INTO [dbo].[Category_Type] (Name,Description,Status,CreatedBy,CreatedOn) VALUES ('Kidswear','Kidswear',2,'system',getDate());
INSERT INTO [dbo].[Category_Type] (Name,Description,Status,CreatedBy,CreatedOn) VALUES ('Lingerie','Lingerie',2,'system',getDate());
INSERT INTO [dbo].[Category_Type] (Name,Description,Status,CreatedBy,CreatedOn) VALUES ('Beauty','Beauty',2,'system',getDate());
INSERT INTO [dbo].[Category_Type] (Name,Description,Status,CreatedBy,CreatedOn) VALUES ('Home Decor','Home Decor',2,'system',getDate());